<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.Statement"%>
<%@page import="java.sql.Connection"%>
<%@page import="connect.Connect"%>

<%@ page language="java" contentType="text/html; charset=UTF-8"
	pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%Connection connection = new Connect().getConnection();
String sql = "Select * from giaovien";
Statement state = connection.createStatement();
ResultSet resultSet = state.executeQuery(sql);
%>
<% while (resultSet.next()) {%>
Ten:
<%= resultSet.getString("HoVaTen")%>, Khoa: 
<%= resultSet.getString("Khoa")%> <br />
<% } %>
</body>
</html>